Pandas Profiling Report

Dataset statistics

Number of variables	12
Number of observations	2968
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	301.4 KiB
Average record size in memory	104.0 B

Variable types

Numeric	12

Alerts

`monetary` is highly overall correlated with `qtde_invoices` and 3 other fields	High correlation
`recency` is highly overall correlated with `qtde_invoices`	High correlation
`qtde_invoices` is highly overall correlated with `monetary` and 3 other fields	High correlation
`qtde_items` is highly overall correlated with `monetary` and 3 other fields	High correlation
`qtde_products` is highly overall correlated with `monetary` and 3 other fields	High correlation
`avg_ticket` is highly overall correlated with `avg_unique_basket_size`	High correlation
`avg_recency_days` is highly overall correlated with `frequency`	High correlation
`frequency` is highly overall correlated with `avg_recency_days`	High correlation
`avg_basket_size` is highly overall correlated with `monetary` and 1 other fields	High correlation
`avg_unique_basket_size` is highly overall correlated with `qtde_products` and 1 other fields	High correlation
`avg_ticket` is highly skewed (γ1 = 53.43524464)	Skewed
`frequency` is highly skewed (γ1 = 24.87657216)	Skewed
`qtdade_itens_retornados` is highly skewed (γ1 = 51.78903194)	Skewed
`avg_basket_size` is highly skewed (γ1 = 44.67603937)	Skewed
`customer_id` has unique values	Unique
`recency` has 34 (1.1%) zeros	Zeros
`qtdade_itens_retornados` has 1480 (49.9%) zeros	Zeros

Reproduction

Analysis started	2023-05-01 19:53:37.984382
Analysis finished	2023-05-01 19:53:53.195827
Duration	15.21 seconds
Software version	ydata-profiling vv4.1.2
Download configuration	config.json

customer_id
Real number (ℝ)

Distinct	2968
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15270.371

Minimum	12347
Maximum	18287
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	46.4 KiB

Quantile statistics

Minimum	12347
5-th percentile	12619.35
Q1	13798.75
median	15220.5
Q3	16768.5
95-th percentile	17964.65
Maximum	18287
Range	5940
Interquartile range (IQR)	2969.75

Descriptive statistics

Standard deviation	1719.1403
Coefficient of variation (CV)	0.11258013
Kurtosis	-1.2061649
Mean	15270.371
Median Absolute Deviation (MAD)	1489
Skewness	0.032199506
Sum	45322461
Variance	2955443.5
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
17850	1	< 0.1%
12670	1	< 0.1%
17734	1	< 0.1%
14905	1	< 0.1%
16103	1	< 0.1%
14626	1	< 0.1%
14868	1	< 0.1%
18246	1	< 0.1%
17115	1	< 0.1%
16611	1	< 0.1%
Other values (2958)	2958	99.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
12347	1	< 0.1%
12348	1	< 0.1%
12352	1	< 0.1%
12356	1	< 0.1%
12358	1	< 0.1%
12359	1	< 0.1%
12360	1	< 0.1%
12362	1	< 0.1%
12364	1	< 0.1%
12370	1	< 0.1%

Value	Count	Frequency (%)
18287	1	< 0.1%
18283	1	< 0.1%
18282	1	< 0.1%
18277	1	< 0.1%
18276	1	< 0.1%
18274	1	< 0.1%
18273	1	< 0.1%
18272	1	< 0.1%
18270	1	< 0.1%
18269	1	< 0.1%

monetary
Real number (ℝ)

Distinct	2953
Distinct (%)	99.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2749.7094

Minimum	6.2
Maximum	279138.02
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	46.4 KiB

Quantile statistics

Minimum	6.2
5-th percentile	229.7325
Q1	570.845
median	1085.51
Q3	2308.805
95-th percentile	7221.795
Maximum	279138.02
Range	279131.82
Interquartile range (IQR)	1737.96

Descriptive statistics

Standard deviation	10582.241
Coefficient of variation (CV)	3.8484942
Kurtosis	353.83989
Mean	2749.7094
Median Absolute Deviation (MAD)	671.625
Skewness	16.775076
Sum	8161137.5
Variance	1.1198382 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1078.96	2	0.1%
2053.02	2	0.1%
331	2	0.1%
1353.74	2	0.1%
889.93	2	0.1%
745.06	2	0.1%
379.65	2	0.1%
2092.32	2	0.1%
731.9	2	0.1%
734.94	2	0.1%
Other values (2943)	2948	99.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
6.2	1	< 0.1%
13.3	1	< 0.1%
15	1	< 0.1%
36.56	1	< 0.1%
45	1	< 0.1%
52	1	< 0.1%
52.2	1	< 0.1%
52.2	1	< 0.1%
62.43	1	< 0.1%
68.84	1	< 0.1%

Value	Count	Frequency (%)
279138.02	1	< 0.1%
259657.3	1	< 0.1%
194550.79	1	< 0.1%
168472.5	1	< 0.1%
140438.72	1	< 0.1%
124564.53	1	< 0.1%
117375.63	1	< 0.1%
91062.38	1	< 0.1%
72882.09	1	< 0.1%
66653.56	1	< 0.1%

recency
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	272
Distinct (%)	9.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	64.303908

Minimum	0
Maximum	373
Zeros	34
Zeros (%)	1.1%
Negative	0
Negative (%)	0.0%
Memory size	46.4 KiB

Quantile statistics

Minimum	0
5-th percentile	2
Q1	11
median	31
Q3	81
95-th percentile	242
Maximum	373
Range	373
Interquartile range (IQR)	70

Descriptive statistics

Standard deviation	77.764827
Coefficient of variation (CV)	1.2093328
Kurtosis	2.7759634
Mean	64.303908
Median Absolute Deviation (MAD)	26
Skewness	1.7978803
Sum	190854
Variance	6047.3683
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	99	3.3%
4	87	2.9%
2	85	2.9%
3	85	2.9%
8	76	2.6%
10	67	2.3%
9	66	2.2%
7	66	2.2%
17	64	2.2%
22	55	1.9%
Other values (262)	2218	74.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	34	1.1%
1	99	3.3%
2	85	2.9%
3	85	2.9%
4	87	2.9%
5	43	1.4%
7	66	2.2%
8	76	2.6%
9	66	2.2%
10	67	2.3%

Value	Count	Frequency (%)
373	2	0.1%
372	4	0.1%
371	1	< 0.1%
368	1	< 0.1%
366	4	0.1%
365	2	0.1%
364	1	< 0.1%
360	1	< 0.1%
359	1	< 0.1%
358	4	0.1%

qtde_invoices
Real number (ℝ)

Distinct	56
Distinct (%)	1.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.7237197

Minimum	1
Maximum	206
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	46.4 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	4
Q3	6
95-th percentile	17
Maximum	206
Range	205
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	8.8580052
Coefficient of variation (CV)	1.5475959
Kurtosis	190.76806
Mean	5.7237197
Median Absolute Deviation (MAD)	2
Skewness	10.764858
Sum	16988
Variance	78.464257
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2	786	26.5%
3	497	16.7%
4	393	13.2%
5	237	8.0%
1	190	6.4%
6	173	5.8%
7	138	4.6%
8	98	3.3%
9	69	2.3%
10	55	1.9%
Other values (46)	332	11.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	190	6.4%
2	786	26.5%
3	497	16.7%
4	393	13.2%
5	237	8.0%
6	173	5.8%
7	138	4.6%
8	98	3.3%
9	69	2.3%
10	55	1.9%

Value	Count	Frequency (%)
206	1	< 0.1%
199	1	< 0.1%
124	1	< 0.1%
97	1	< 0.1%
91	2	0.1%
86	1	< 0.1%
72	1	< 0.1%
62	2	0.1%
60	1	< 0.1%
57	1	< 0.1%

qtde_items
Real number (ℝ)

Distinct	1665
Distinct (%)	56.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1606.6779

Minimum	1
Maximum	196844
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	46.4 KiB

Quantile statistics

Minimum	1
5-th percentile	101.35
Q1	296
median	638
Q3	1399
95-th percentile	4407.6
Maximum	196844
Range	196843
Interquartile range (IQR)	1103

Descriptive statistics

Standard deviation	5883.956
Coefficient of variation (CV)	3.6621877
Kurtosis	466.99678
Mean	1606.6779
Median Absolute Deviation (MAD)	419.5
Skewness	17.875434
Sum	4768620
Variance	34620938
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
310	11	0.4%
88	9	0.3%
150	9	0.3%
260	8	0.3%
84	8	0.3%
288	8	0.3%
272	8	0.3%
246	8	0.3%
516	7	0.2%
394	7	0.2%
Other values (1655)	2885	97.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1	< 0.1%
2	2	0.1%
12	2	0.1%
16	1	< 0.1%
17	1	< 0.1%
18	1	< 0.1%
19	1	< 0.1%
20	1	< 0.1%
23	1	< 0.1%
25	1	< 0.1%

Value	Count	Frequency (%)
196844	1	< 0.1%
80997	1	< 0.1%
79963	1	< 0.1%
77373	1	< 0.1%
69993	1	< 0.1%
64549	1	< 0.1%
64124	1	< 0.1%
62812	1	< 0.1%
58243	1	< 0.1%
57785	1	< 0.1%

qtde_products
Real number (ℝ)

Distinct	469
Distinct (%)	15.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	122.66712

Minimum	1
Maximum	7837
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	46.4 KiB

Quantile statistics

Minimum	1
5-th percentile	9
Q1	29
median	67
Q3	135
95-th percentile	382
Maximum	7837
Range	7836
Interquartile range (IQR)	106

Descriptive statistics

Standard deviation	269.87945
Coefficient of variation (CV)	2.2000961
Kurtosis	354.76843
Mean	122.66712
Median Absolute Deviation (MAD)	44
Skewness	15.705296
Sum	364076
Variance	72834.917
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
28	45	1.5%
20	38	1.3%
35	35	1.2%
29	33	1.1%
19	33	1.1%
15	33	1.1%
11	32	1.1%
26	31	1.0%
27	30	1.0%
6	29	1.0%
Other values (459)	2629	88.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	6	0.2%
2	14	0.5%
3	16	0.5%
4	17	0.6%
5	26	0.9%
6	29	1.0%
7	18	0.6%
8	19	0.6%
9	27	0.9%
10	27	0.9%

Value	Count	Frequency (%)
7837	1	< 0.1%
5670	1	< 0.1%
5095	1	< 0.1%
4577	1	< 0.1%
2698	1	< 0.1%
2379	1	< 0.1%
2060	1	< 0.1%
1818	1	< 0.1%
1673	1	< 0.1%
1636	1	< 0.1%

avg_ticket
Real number (ℝ)

HIGH CORRELATION SKEWED

Distinct	2965
Distinct (%)	99.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	51.915666

Minimum	2.1505882
Maximum	56157.5
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	46.4 KiB

Quantile statistics

Minimum	2.1505882
5-th percentile	4.915888
Q1	13.120801
median	17.977335
Q3	24.989429
95-th percentile	90.498417
Maximum	56157.5
Range	56155.349
Interquartile range (IQR)	11.868627

Descriptive statistics

Standard deviation	1037.1087
Coefficient of variation (CV)	19.976797
Kurtosis	2889.7351
Mean	51.915666
Median Absolute Deviation (MAD)	5.9901484
Skewness	53.435245
Sum	154085.7
Variance	1075594.5
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
15	2	0.1%
4.162	2	0.1%
14.47833333	2	0.1%
18.15222222	1	< 0.1%
13.92736842	1	< 0.1%
36.24411765	1	< 0.1%
29.78416667	1	< 0.1%
22.8792623	1	< 0.1%
20.51104167	1	< 0.1%
149.025	1	< 0.1%
Other values (2955)	2955	99.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2.150588235	1	< 0.1%
2.4325	1	< 0.1%
2.462371134	1	< 0.1%
2.511241379	1	< 0.1%
2.515333333	1	< 0.1%
2.65	1	< 0.1%
2.656931818	1	< 0.1%
2.707598253	1	< 0.1%
2.760621572	1	< 0.1%
2.770464191	1	< 0.1%

Value	Count	Frequency (%)
56157.5	1	< 0.1%
4453.43	1	< 0.1%
3202.92	1	< 0.1%
1687.2	1	< 0.1%
952.9875	1	< 0.1%
872.13	1	< 0.1%
841.0214493	1	< 0.1%
651.1683333	1	< 0.1%
640	1	< 0.1%
624.4	1	< 0.1%

avg_recency_days
Real number (ℝ)

Distinct	1258
Distinct (%)	42.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	67.353402

Minimum	1
Maximum	366
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	46.4 KiB

Quantile statistics

Minimum	1
5-th percentile	8
Q1	25.927198
median	48.267857
Q3	85.375
95-th percentile	201
Maximum	366
Range	365
Interquartile range (IQR)	59.447802

Descriptive statistics

Standard deviation	63.553446
Coefficient of variation (CV)	0.94358183
Kurtosis	4.8848377
Mean	67.353402
Median Absolute Deviation (MAD)	26.267857
Skewness	2.0624779
Sum	199904.9
Variance	4039.0405
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
14	25	0.8%
4	22	0.7%
70	21	0.7%
7	20	0.7%
35	19	0.6%
49	18	0.6%
21	17	0.6%
46	17	0.6%
11	17	0.6%
1	16	0.5%
Other values (1248)	2776	93.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	16	0.5%
1.5	1	< 0.1%
2	13	0.4%
2.5	1	< 0.1%
2.601398601	1	< 0.1%
3	15	0.5%
3.321428571	1	< 0.1%
3.330357143	1	< 0.1%
3.5	2	0.1%
4	22	0.7%

Value	Count	Frequency (%)
366	1	< 0.1%
365	1	< 0.1%
363	1	< 0.1%
362	1	< 0.1%
357	2	0.1%
356	1	< 0.1%
355	2	0.1%
352	1	< 0.1%
351	2	0.1%
350	3	0.1%

frequency
Real number (ℝ)

HIGH CORRELATION SKEWED

Distinct	1224
Distinct (%)	41.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.11382141

Minimum	0.0054495913
Maximum	17
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	46.4 KiB

Quantile statistics

Minimum	0.0054495913
5-th percentile	0.0088935048
Q1	0.016336535
median	0.025898352
Q3	0.049426591
95-th percentile	1
Maximum	17
Range	16.99455
Interquartile range (IQR)	0.033090056

Descriptive statistics

Standard deviation	0.40822261
Coefficient of variation (CV)	3.5865187
Kurtosis	989.04899
Mean	0.11382141
Median Absolute Deviation (MAD)	0.012196886
Skewness	24.876572
Sum	337.82195
Variance	0.1666457
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	198	6.7%
0.02777777778	17	0.6%
0.0625	17	0.6%
0.02380952381	16	0.5%
0.08333333333	15	0.5%
0.09090909091	15	0.5%
0.02941176471	14	0.5%
0.03448275862	14	0.5%
0.02564102564	13	0.4%
0.02127659574	13	0.4%
Other values (1214)	2636	88.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.005449591281	1	< 0.1%
0.005464480874	1	< 0.1%
0.005479452055	1	< 0.1%
0.005494505495	1	< 0.1%
0.005586592179	2	0.1%
0.005602240896	1	< 0.1%
0.005617977528	2	0.1%
0.00566572238	1	< 0.1%
0.005681818182	2	0.1%
0.005698005698	3	0.1%

Value	Count	Frequency (%)
17	1	< 0.1%
3	1	< 0.1%
2	6	0.2%
1.142857143	1	< 0.1%
1	198	6.7%
0.75	1	< 0.1%
0.6666666667	3	0.1%
0.550802139	1	< 0.1%
0.5335120643	1	< 0.1%
0.5	3	0.1%

qtdade_itens_retornados
Real number (ℝ)

SKEWED ZEROS

Distinct	214
Distinct (%)	7.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	62.177898

Minimum	0
Maximum	80995
Zeros	1480
Zeros (%)	49.9%
Negative	0
Negative (%)	0.0%
Memory size	46.4 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	1
Q3	9
95-th percentile	100.65
Maximum	80995
Range	80995
Interquartile range (IQR)	9

Descriptive statistics

Standard deviation	1512.7506
Coefficient of variation (CV)	24.329394
Kurtosis	2764.598
Mean	62.177898
Median Absolute Deviation (MAD)	1
Skewness	51.789032
Sum	184544
Variance	2288414.3
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1480	49.9%
1	164	5.5%
2	148	5.0%
3	105	3.5%
4	89	3.0%
6	78	2.6%
5	61	2.1%
12	51	1.7%
8	43	1.4%
7	43	1.4%
Other values (204)	706	23.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1480	49.9%
1	164	5.5%
2	148	5.0%
3	105	3.5%
4	89	3.0%
5	61	2.1%
6	78	2.6%
7	43	1.4%
8	43	1.4%
9	41	1.4%

Value	Count	Frequency (%)
80995	1	< 0.1%
9014	1	< 0.1%
8004	1	< 0.1%
4427	1	< 0.1%
3768	1	< 0.1%
3332	1	< 0.1%
2878	1	< 0.1%
2022	1	< 0.1%
2012	1	< 0.1%
1776	1	< 0.1%

avg_basket_size
Real number (ℝ)

HIGH CORRELATION SKEWED

Distinct	1973
Distinct (%)	66.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	249.3254

Minimum	1
Maximum	40498.5
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	46.4 KiB

Quantile statistics

Minimum	1
5-th percentile	44
Q1	103.2375
median	172
Q3	281.375
95-th percentile	599.58
Maximum	40498.5
Range	40497.5
Interquartile range (IQR)	178.1375

Descriptive statistics

Standard deviation	791.63469
Coefficient of variation (CV)	3.1751065
Kurtosis	2255.5038
Mean	249.3254
Median Absolute Deviation (MAD)	82.625
Skewness	44.676039
Sum	739997.79
Variance	626685.48
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
100	11	0.4%
114	10	0.3%
73	9	0.3%
86	9	0.3%
82	9	0.3%
136	8	0.3%
60	8	0.3%
75	8	0.3%
88	8	0.3%
71	7	0.2%
Other values (1963)	2881	97.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	2	0.1%
2	1	< 0.1%
3.333333333	1	< 0.1%
5.333333333	1	< 0.1%
5.666666667	1	< 0.1%
6.142857143	1	< 0.1%
7.5	1	< 0.1%
9	1	< 0.1%
9.5	1	< 0.1%
11	1	< 0.1%

Value	Count	Frequency (%)
40498.5	1	< 0.1%
6009.333333	1	< 0.1%
4282	1	< 0.1%
3906	1	< 0.1%
3868.65	1	< 0.1%
2880	1	< 0.1%
2801	1	< 0.1%
2733.944444	1	< 0.1%
2518.769231	1	< 0.1%
2160.333333	1	< 0.1%

avg_unique_basket_size
Real number (ℝ)

Distinct	909
Distinct (%)	30.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	17.473826

Minimum	0.2
Maximum	259
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	46.4 KiB

Quantile statistics

Minimum	0.2
5-th percentile	2
Q1	7.6666667
median	13.6
Q3	22
95-th percentile	45.9125
Maximum	259
Range	258.8
Interquartile range (IQR)	14.333333

Descriptive statistics

Standard deviation	15.452856
Coefficient of variation (CV)	0.88434305
Kurtosis	29.388198
Mean	17.473826
Median Absolute Deviation (MAD)	6.6
Skewness	3.4401001
Sum	51862.315
Variance	238.79077
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
13	43	1.4%
9	42	1.4%
16	41	1.4%
8	39	1.3%
17	37	1.2%
14	37	1.2%
11	36	1.2%
7	36	1.2%
15	34	1.1%
5	34	1.1%
Other values (899)	2589	87.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.2	1	< 0.1%
0.25	3	0.1%
0.3333333333	6	0.2%
0.4	1	< 0.1%
0.4090909091	1	< 0.1%
0.5	12	0.4%
0.5454545455	1	< 0.1%
0.5555555556	1	< 0.1%
0.5714285714	1	< 0.1%
0.6176470588	1	< 0.1%

Value	Count	Frequency (%)
259	1	< 0.1%
177	1	< 0.1%
148	1	< 0.1%
127	1	< 0.1%
105	1	< 0.1%
104	1	< 0.1%
101	1	< 0.1%
98	1	< 0.1%
95.5	1	< 0.1%
94.33333333	1	< 0.1%

Auto

Heatmap
Table

	customer_id	monetary	recency	qtde_invoices	qtde_items	qtde_products	avg_ticket	avg_recency_days	frequency	qtdade_itens_retornados	avg_basket_size	avg_unique_basket_size
customer_id	1.000	-0.076	0.001	0.025	-0.070	0.012	-0.130	0.019	-0.002	-0.063	-0.123	-0.017
monetary	-0.076	1.000	-0.415	0.770	0.927	0.744	0.246	-0.248	0.090	0.372	0.576	0.104
recency	0.001	-0.415	1.000	-0.502	-0.408	-0.435	0.047	0.108	0.019	-0.120	-0.098	0.015
qtde_invoices	0.025	0.770	-0.502	1.000	0.717	0.690	0.059	-0.258	0.078	0.293	0.101	-0.181
qtde_items	-0.070	0.927	-0.408	0.717	1.000	0.731	0.168	-0.227	0.080	0.345	0.729	0.147
qtde_products	0.012	0.744	-0.435	0.690	0.731	1.000	-0.377	-0.166	0.036	0.243	0.384	0.516
avg_ticket	-0.130	0.246	0.047	0.059	0.168	-0.377	1.000	-0.122	0.091	0.189	0.189	-0.618
avg_recency_days	0.019	-0.248	0.108	-0.258	-0.227	-0.166	-0.122	1.000	-0.881	-0.396	-0.077	0.130
frequency	-0.002	0.090	0.019	0.078	0.080	0.036	0.091	-0.881	1.000	0.234	0.027	-0.121
qtdade_itens_retornados	-0.063	0.372	-0.120	0.293	0.345	0.243	0.189	-0.396	0.234	1.000	0.212	-0.053
avg_basket_size	-0.123	0.576	-0.098	0.101	0.729	0.384	0.189	-0.077	0.027	0.212	1.000	0.403
avg_unique_basket_size	-0.017	0.104	0.015	-0.181	0.147	0.516	-0.618	0.130	-0.121	-0.053	0.403	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	customer_id	monetary	recency	qtde_invoices	qtde_items	qtde_products	avg_ticket	avg_recency_days	frequency	qtdade_itens_retornados	avg_basket_size	avg_unique_basket_size
0	17850	5391.21	372.00	34.00	1733.00	297.00	18.15	35.50	17.00	40.00	50.97	0.62
1	13047	3232.59	56.00	9.00	1390.00	171.00	18.90	27.25	0.03	35.00	154.44	11.67
2	12583	6705.38	2.00	15.00	5028.00	232.00	28.90	23.19	0.04	50.00	335.20	7.60
3	13748	948.25	95.00	5.00	439.00	28.00	33.87	92.67	0.02	0.00	87.80	4.80
4	15100	876.00	333.00	3.00	80.00	3.00	292.00	8.60	0.07	22.00	26.67	0.33
5	15291	4623.30	25.00	14.00	2102.00	102.00	45.33	23.20	0.04	29.00	150.14	4.36
6	14688	5630.87	7.00	21.00	3621.00	327.00	17.22	18.30	0.06	399.00	172.43	7.05
7	17809	5411.91	16.00	12.00	2057.00	61.00	88.72	35.70	0.03	41.00	171.42	3.83
8	15311	60767.90	0.00	91.00	38194.00	2379.00	25.54	4.14	0.24	474.00	419.71	6.23
9	16098	2005.63	87.00	7.00	613.00	67.00	29.93	47.67	0.02	0.00	87.57	4.86

	customer_id	monetary	recency	qtde_invoices	qtde_items	qtde_products	avg_ticket	avg_recency_days	frequency	qtdade_itens_retornados	avg_basket_size	avg_unique_basket_size
5626	17727	1060.25	15.00	1.00	645.00	66.00	16.06	6.00	1.00	6.00	645.00	66.00
5636	17232	421.52	2.00	2.00	203.00	36.00	11.71	12.00	0.15	0.00	101.50	15.00
5637	17468	137.00	10.00	2.00	116.00	5.00	27.40	4.00	0.40	0.00	58.00	2.50
5648	13596	697.04	5.00	2.00	406.00	166.00	4.20	7.00	0.25	0.00	203.00	66.50
5654	14893	1237.85	9.00	2.00	799.00	73.00	16.96	2.00	0.67	0.00	399.50	36.00
5658	12479	473.20	11.00	1.00	382.00	30.00	15.77	4.00	1.00	34.00	382.00	30.00
5679	14126	706.13	7.00	3.00	508.00	15.00	47.08	3.00	0.75	50.00	169.33	4.67
5685	13521	1092.39	1.00	3.00	733.00	435.00	2.51	4.50	0.30	0.00	244.33	104.00
5695	15060	301.84	8.00	4.00	262.00	120.00	2.52	1.00	2.00	0.00	65.50	20.00
5714	12558	269.96	7.00	1.00	196.00	11.00	24.54	6.00	1.00	196.00	196.00	11.00

Overview

Variables

Interactions

Correlations

Missing values

Sample